home *** CD-ROM | disk | FTP | other *** search
/ Yellow Pages USA 1999 / Yellow Pages USA 1999.iso / _setup.1 / AYP98.dbd < prev    next >
Text File  |  1998-06-05  |  4KB  |  189 lines
  1. ; Database definition file for Yellow Pages 1999
  2.  
  3. [General]
  4. Signature=0x02982
  5. Cache Size=100
  6. Checksum=0
  7. FieldDecoder=internal
  8. Partitions=0
  9. BoughtList=1
  10.  
  11. [Physical Files]
  12. Default=?:\b
  13. D=?:\b\ypud.99,5
  14. I=?:\b\ypui.98,5
  15. E=?:\b\ypue.99,5
  16.  
  17. [Logical Files]
  18. Word=E,B,0,6400000,1
  19. City=E,B,19054592,19269632,1
  20. Sic=E,B,23773184,23820288,1
  21.  
  22. [Data]
  23. Index=D, 0, 2883584
  24. Data=D, 2883584
  25.  
  26. [Indexes]
  27. Count=10
  28. 1=City,F
  29. 2=Name,F
  30. 3=Sic2,E
  31. 4=State,E
  32. 5=Zipcode,F
  33. 6=Sic1,E
  34. 7=Phone,B
  35. 8=Longitude,B
  36. 9=Latitude,B
  37. 10=Address,B
  38.  
  39. [Latitude]
  40. Word=I, 0, 0
  41. Rec=I, 0, 0
  42. Field=1
  43. Format=%s
  44. Split=0
  45.  
  46. [Longitude]
  47. Word=I, 0, 0
  48. Rec=I, 0, 0
  49. Field=1
  50. Format=%s
  51. Split=0
  52.  
  53. [City]
  54. Word=I, 0, 6144
  55. Rec=I, 405504
  56. Split=1
  57.  
  58. [Name]
  59. Word=I, 14618624, 14778368
  60. Rec=I, 33118208
  61. Split=1
  62.  
  63. [Sic2]
  64. TA Word=I,122941440,122947584
  65. TA Rec=I,123310080
  66. Enum=I,8940,123600896,123865088,1
  67. Rec=I,123865088
  68. Split=0
  69.  
  70. [State]
  71. TA Word=I,174411776,174413824
  72. TA Rec=I,174430208
  73. Enum=I,51,174436352,174438400,1
  74. Rec=I,174438400
  75. TD=1
  76.  
  77. [Zipcode]
  78. Word=I, 185356288, 185366528
  79. Rec=I, 186273792
  80. Split=1
  81.  
  82. [Sic1]
  83. TA Word=I,197648384,197730304
  84. TA Rec=I,203884544
  85. Enum=I,17348,206782464,207763456,1
  86. Rec=I,123865088
  87. Word=I,123600896
  88. Index=I,207763456
  89. TD=1
  90.  
  91. [Phone]
  92. Word=I, 207833088, 432128
  93. Rec=I, 208265216, 42799104
  94. Field=9,11
  95. Format=%s,%s
  96. Split=1
  97.  
  98. [County]
  99. TA Word=I,251064320,251072512
  100. TA Rec=I,251602944
  101. Enum=I,3140,251842560,251959296,1
  102. Rec=I,251959296
  103. TD=1
  104. CL=0
  105. EM=1
  106.  
  107. [Address]
  108. Word=I, 263073792, 1073152
  109. Rec=I, 264146944, 41742336
  110. Field=3,4,5
  111. Format=%-30s,%010s,%010s
  112. Split=0
  113.  
  114. [MSA]
  115. TA Word=I,305889280,305891328
  116. TA Rec=I,306003968
  117. Enum=I,328,306034688,306051072,1
  118. Rec=I,306051072
  119. TD=1
  120. CL=0
  121. EM=1
  122.  
  123. [Field Info]
  124. Count=64
  125. 1=Company Name,COMPANY,50,0
  126. 2=Address,ADDRESS,50,0
  127. 3=Address Name,ADDRNAME,50,0
  128. 4=Address Number,ADDRNUM,10,0
  129. 5=Address Secondary Number,ADDRSNUM,10,0
  130. 6=City,CITY,16,0
  131. 7=State,ST,2,0
  132. 8=ZIP Code,ZIP,5,0
  133. 9=Area Code,AC,3,0
  134. 10=County Code,CO,3,0
  135. 11=Phone,PHONE,7,0
  136. 12=Areacode/Phone,ACPHONE,14,0
  137. 13=Fax,FAX,14,0
  138. 14=Latitude,LATITUDE,12,0
  139. 15=Longitude,LONGITUDE,12,0
  140. 16=Match Level,MATCHLEVEL,20,0
  141. 17=SIC Code #1,SIC1,7,0
  142. 18=Line of Business #1,LOB1,50,0
  143. 19=Ad Size #1,A1,12,0
  144. 20=Year #1,YR1,3,0
  145. 21=Franchise #1-1,FRAN11,50,0
  146. 22=Franchise #1-2,FRAN12,50,0
  147. 23=Franchise #1-3,FRAN13,50,0
  148. 24=Franchise #1-4,FRAN14,50,0
  149. 25=SIC Code #2,SIC2,7,0
  150. 26=Line of Business #2,LOB2,50,0
  151. 27=Ad Size #2,A2,12,0
  152. 28=Year #2,YR2,3,0
  153. 29=Franchise #2-1,FRAN21,50,0
  154. 30=Franchise #2-2,FRAN22,50,0
  155. 31=Franchise #2-3,FRAN23,50,0
  156. 32=Franchise #2-4,FRAN24,50,0
  157. 33=SIC Code #3,SIC3,7,0
  158. 34=Line of Business #3,LOB3,50,0
  159. 35=Ad Size #3,A3,12,0
  160. 36=Year #3,YR3,3,0
  161. 37=Franchise #3-1,FRAN31,50,0
  162. 38=Franchise #3-2,FRAN32,50,0
  163. 39=Franchise #3-3,FRAN33,50,0
  164. 40=Franchise #3-4,FRAN34,50,0
  165. 41=SIC Code #4,SIC4,7,0
  166. 42=Line of Business #4,LOB4,50,0
  167. 43=Ad Size #4,A4,12,0
  168. 44=Year #4,YR4,3,0
  169. 45=Franchise #4-1,FRAN41,50,0
  170. 46=Franchise #4-2,FRAN42,50,0
  171. 47=Franchise #4-3,FRAN43,50,0
  172. 48=Franchise #4-4,FRAN44,50,0
  173. 49=SIC Code #5,SIC5,7,0
  174. 50=Line of Business #5,LOB5,50,0
  175. 51=Ad Size #5,A5,12,0
  176. 52=Year #5,YR5,3,0
  177. 53=Franchise #5-1,FRAN51,50,0
  178. 54=Franchise #5-2,FRAN52,50,0
  179. 55=Franchise #5-3,FRAN53,50,0
  180. 56=Franchise #5-4,FRAN54,50,0
  181. 57=SIC Code #6,SIC6,7,0
  182. 58=Line of Business #6,LOB6,50,0
  183. 59=Ad Size #6,A6,12,0
  184. 60=Year #6,YR6,3,0
  185. 61=Franchise #6-1,FRAN61,50,0
  186. 62=Franchise #6-2,FRAN62,50,0
  187. 63=Franchise #6-3,FRAN63,50,0
  188. 64=Franchise #6-4,FRAN64,50,0
  189.